Pandas Profiling Report

Dataset statistics

Number of variables	14
Number of observations	5309
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	580.8 KiB
Average record size in memory	112.0 B

Variable types

Numeric	13
Categorical	1

Alerts

`df_index` is highly correlated with `type` and 1 other fields	High correlation
`type` is highly correlated with `df_index` and 4 other fields	High correlation
`volatile acidity` is highly correlated with `type`	High correlation
`chlorides` is highly correlated with `type` and 1 other fields	High correlation
`free sulfur dioxide` is highly correlated with `type` and 1 other fields	High correlation
`total sulfur dioxide` is highly correlated with `df_index` and 2 other fields	High correlation
`density` is highly correlated with `chlorides` and 1 other fields	High correlation
`alcohol` is highly correlated with `density`	High correlation
`df_index` is highly correlated with `type` and 1 other fields	High correlation
`type` is highly correlated with `df_index` and 2 other fields	High correlation
`volatile acidity` is highly correlated with `type`	High correlation
`residual sugar` is highly correlated with `density`	High correlation
`free sulfur dioxide` is highly correlated with `total sulfur dioxide`	High correlation
`total sulfur dioxide` is highly correlated with `df_index` and 2 other fields	High correlation
`density` is highly correlated with `residual sugar` and 1 other fields	High correlation
`alcohol` is highly correlated with `density`	High correlation
`df_index` is highly correlated with `type`	High correlation
`type` is highly correlated with `df_index` and 2 other fields	High correlation
`chlorides` is highly correlated with `type`	High correlation
`free sulfur dioxide` is highly correlated with `total sulfur dioxide`	High correlation
`total sulfur dioxide` is highly correlated with `type` and 1 other fields	High correlation
`density` is highly correlated with `alcohol`	High correlation
`alcohol` is highly correlated with `density`	High correlation
`df_index` is highly correlated with `type` and 3 other fields	High correlation
`type` is highly correlated with `df_index` and 4 other fields	High correlation
`fixed acidity` is highly correlated with `df_index` and 3 other fields	High correlation
`volatile acidity` is highly correlated with `df_index` and 1 other fields	High correlation
`residual sugar` is highly correlated with `density`	High correlation
`chlorides` is highly correlated with `type` and 1 other fields	High correlation
`free sulfur dioxide` is highly correlated with `total sulfur dioxide`	High correlation
`total sulfur dioxide` is highly correlated with `df_index` and 2 other fields	High correlation
`density` is highly correlated with `fixed acidity` and 2 other fields	High correlation
`sulphates` is highly correlated with `chlorides`	High correlation
`alcohol` is highly correlated with `fixed acidity` and 1 other fields	High correlation
`df_index` has unique values	Unique
`citric acid` has 135 (2.5%) zeros	Zeros

Reproduction

Analysis started	2021-10-01 08:00:10.413195
Analysis finished	2021-10-01 08:00:45.837643
Duration	35.42 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	5309
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3250.84498

Minimum	0
Maximum	6496
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	41.6 KiB

Quantile statistics

Minimum	0
5-th percentile	317.4
Q1	1579
median	3240
Q3	4927
95-th percentile	6173.6
Maximum	6496
Range	6496
Interquartile range (IQR)	3348

Descriptive statistics

Standard deviation	1897.569775
Coefficient of variation (CV)	0.5837158604
Kurtosis	-1.239922084
Mean	3250.84498
Median Absolute Deviation (MAD)	1674
Skewness	-0.002673063995
Sum	17258736
Variance	3600771.05
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
4416	1	< 0.1%
4412	1	< 0.1%
4411	1	< 0.1%
4410	1	< 0.1%
4408	1	< 0.1%
4407	1	< 0.1%
4406	1	< 0.1%
4404	1	< 0.1%
4403	1	< 0.1%
Other values (5299)	5299	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
6	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%
11	1	< 0.1%
12	1	< 0.1%
13	1	< 0.1%

Value	Count	Frequency (%)
6496	1	< 0.1%
6495	1	< 0.1%
6492	1	< 0.1%
6491	1	< 0.1%
6490	1	< 0.1%
6489	1	< 0.1%
6488	1	< 0.1%
6487	1	< 0.1%
6486	1	< 0.1%
6485	1	< 0.1%

type
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	41.6 KiB

2	3955
1	1354

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2
2nd row	2
3rd row	2
4th row	2
5th row	2

Common Values

Value	Count	Frequency (%)
2	3955	74.5%
1	1354	25.5%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
2	3955	74.5%
1	1354	25.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

fixed acidity
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	106
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.217263138

Minimum	3.8
Maximum	15.9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	41.6 KiB

Quantile statistics

Minimum	3.8
5-th percentile	5.6
Q1	6.4
median	7
Q3	7.7
95-th percentile	9.8
Maximum	15.9
Range	12.1
Interquartile range (IQR)	1.3

Descriptive statistics

Standard deviation	1.319173097
Coefficient of variation (CV)	0.1827802411
Kurtosis	4.600489437
Mean	7.217263138
Median Absolute Deviation (MAD)	0.6
Skewness	1.651702401
Sum	38316.45
Variance	1.740217659
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6.8	278	5.2%
6.6	268	5.0%
6.4	245	4.6%
7	229	4.3%
6.9	225	4.2%
6.7	211	4.0%
7.2	202	3.8%
7.1	200	3.8%
6.5	196	3.7%
6.2	176	3.3%
Other values (96)	3079	58.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3.8	1	< 0.1%
3.9	1	< 0.1%
4.2	2	< 0.1%
4.4	3	0.1%
4.5	1	< 0.1%
4.6	2	< 0.1%
4.7	6	0.1%
4.8	9	0.2%
4.9	6	0.1%
5	26	0.5%

Value	Count	Frequency (%)
15.9	1	< 0.1%
15.6	2	< 0.1%
15.5	1	< 0.1%
15	1	< 0.1%
14.3	1	< 0.1%
14.2	1	< 0.1%
14	1	< 0.1%
13.8	1	< 0.1%
13.7	1	< 0.1%
13.5	1	< 0.1%

volatile acidity
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	188
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.3435543417

Minimum	0
Maximum	1.58
Zeros	8
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	41.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0.16
Q1	0.23
median	0.3
Q3	0.41
95-th percentile	0.68
Maximum	1.58
Range	1.58
Interquartile range (IQR)	0.18

Descriptive statistics

Standard deviation	0.1686638667
Coefficient of variation (CV)	0.4909379571
Kurtosis	2.856768376
Mean	0.3435543417
Median Absolute Deviation (MAD)	0.08
Skewness	1.491758728
Sum	1823.93
Variance	0.02844749992
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.28	231	4.4%
0.26	218	4.1%
0.24	217	4.1%
0.27	188	3.5%
0.25	186	3.5%
0.22	182	3.4%
0.23	177	3.3%
0.2	177	3.3%
0.3	168	3.2%
0.21	163	3.1%
Other values (178)	3402	64.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	8	0.2%
0.08	2	< 0.1%
0.085	1	< 0.1%
0.09	1	< 0.1%
0.1	6	0.1%
0.105	4	0.1%
0.11	9	0.2%
0.115	3	0.1%
0.12	28	0.5%
0.125	2	< 0.1%

Value	Count	Frequency (%)
1.58	1	< 0.1%
1.33	2	< 0.1%
1.24	1	< 0.1%
1.185	1	< 0.1%
1.18	1	< 0.1%
1.13	1	< 0.1%
1.115	1	< 0.1%
1.1	1	< 0.1%
1.09	1	< 0.1%
1.07	1	< 0.1%

citric acid
Real number (ℝ_≥0)

ZEROS

Distinct	89
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.3187944999

Minimum	0
Maximum	1.66
Zeros	135
Zeros (%)	2.5%
Negative	0
Negative (%)	0.0%
Memory size	41.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0.04
Q1	0.24
median	0.31
Q3	0.4
95-th percentile	0.56
Maximum	1.66
Range	1.66
Interquartile range (IQR)	0.16

Descriptive statistics

Standard deviation	0.1470978256
Coefficient of variation (CV)	0.461418957
Kurtosis	2.591333435
Mean	0.3187944999
Median Absolute Deviation (MAD)	0.07
Skewness	0.4862039596
Sum	1692.48
Variance	0.02163777031
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.3	264	5.0%
0.32	240	4.5%
0.28	236	4.4%
0.49	232	4.4%
0.26	204	3.8%
0.34	202	3.8%
0.29	198	3.7%
0.31	187	3.5%
0.24	184	3.5%
0.27	179	3.4%
Other values (79)	3183	60.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	135	2.5%
0.01	31	0.6%
0.02	44	0.8%
0.03	26	0.5%
0.04	34	0.6%
0.05	23	0.4%
0.06	25	0.5%
0.07	27	0.5%
0.08	36	0.7%
0.09	34	0.6%

Value	Count	Frequency (%)
1.66	1	< 0.1%
1.23	1	< 0.1%
1	6	0.1%
0.99	1	< 0.1%
0.91	1	< 0.1%
0.88	1	< 0.1%
0.86	1	< 0.1%
0.82	2	< 0.1%
0.81	2	< 0.1%
0.8	1	< 0.1%

residual sugar
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	316
Distinct (%)	6.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.051798832

Minimum	0.6
Maximum	65.8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	41.6 KiB

Quantile statistics

Minimum	0.6
5-th percentile	1.1
Q1	1.8
median	2.7
Q3	7.5
95-th percentile	14.4
Maximum	65.8
Range	65.2
Interquartile range (IQR)	5.7

Descriptive statistics

Standard deviation	4.501714492
Coefficient of variation (CV)	0.8911111946
Kurtosis	7.025523086
Mean	5.051798832
Median Absolute Deviation (MAD)	1.5
Skewness	1.705777895
Sum	26820
Variance	20.26543337
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	200	3.8%
1.6	199	3.7%
1.4	194	3.7%
1.8	192	3.6%
1.2	173	3.3%
2.2	156	2.9%
1.5	149	2.8%
2.1	148	2.8%
1.9	148	2.8%
1.7	148	2.8%
Other values (306)	3602	67.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.6	1	< 0.1%
0.7	7	0.1%
0.8	25	0.5%
0.9	35	0.7%
0.95	3	0.1%
1	77	1.5%
1.05	1	< 0.1%
1.1	126	2.4%
1.15	3	0.1%
1.2	173	3.3%

Value	Count	Frequency (%)
65.8	1	< 0.1%
31.6	1	< 0.1%
26.05	1	< 0.1%
23.5	1	< 0.1%
22.6	1	< 0.1%
22	1	< 0.1%
20.8	2	< 0.1%
20.7	1	< 0.1%
20.4	1	< 0.1%
20.3	1	< 0.1%

chlorides
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	214
Distinct (%)	4.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.05666811076

Minimum	0.009
Maximum	0.611
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	41.6 KiB

Quantile statistics

Minimum	0.009
5-th percentile	0.028
Q1	0.038
median	0.047
Q3	0.066
95-th percentile	0.104
Maximum	0.611
Range	0.602
Interquartile range (IQR)	0.028

Descriptive statistics

Standard deviation	0.03686076168
Coefficient of variation (CV)	0.6504674533
Kurtosis	48.3849435
Mean	0.05666811076
Median Absolute Deviation (MAD)	0.011
Skewness	5.348422871
Sum	300.851
Variance	0.001358715752
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.036	165	3.1%
0.044	160	3.0%
0.042	158	3.0%
0.046	155	2.9%
0.04	152	2.9%
0.047	148	2.8%
0.048	143	2.7%
0.05	141	2.7%
0.038	141	2.7%
0.034	137	2.6%
Other values (204)	3809	71.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.009	1	< 0.1%
0.012	2	< 0.1%
0.013	1	< 0.1%
0.014	4	0.1%
0.015	3	0.1%
0.016	5	0.1%
0.017	5	0.1%
0.018	8	0.2%
0.019	7	0.1%
0.02	13	0.2%

Value	Count	Frequency (%)
0.611	1	< 0.1%
0.61	1	< 0.1%
0.467	1	< 0.1%
0.464	1	< 0.1%
0.422	1	< 0.1%
0.415	2	< 0.1%
0.414	2	< 0.1%
0.413	1	< 0.1%
0.403	1	< 0.1%
0.401	1	< 0.1%

free sulfur dioxide
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	135
Distinct (%)	2.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	30.04426446

Minimum	1
Maximum	289
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	41.6 KiB

Quantile statistics

Minimum	1
5-th percentile	6
Q1	16
median	28
Q3	41
95-th percentile	61
Maximum	289
Range	288
Interquartile range (IQR)	25

Descriptive statistics

Standard deviation	17.8159925
Coefficient of variation (CV)	0.5929914686
Kurtosis	9.51294538
Mean	30.04426446
Median Absolute Deviation (MAD)	12
Skewness	1.362895506
Sum	159505
Variance	317.4095889
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6	150	2.8%
29	144	2.7%
26	134	2.5%
15	132	2.5%
24	127	2.4%
17	124	2.3%
34	123	2.3%
31	123	2.3%
23	121	2.3%
28	115	2.2%
Other values (125)	4016	75.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2	< 0.1%
2	2	< 0.1%
3	50	0.9%
4	42	0.8%
5	111	2.1%
5.5	1	< 0.1%
6	150	2.8%
7	82	1.5%
8	77	1.5%
9	80	1.5%

Value	Count	Frequency (%)
289	1	< 0.1%
146.5	1	< 0.1%
138.5	1	< 0.1%
131	1	< 0.1%
128	1	< 0.1%
124	1	< 0.1%
122.5	1	< 0.1%
118.5	1	< 0.1%
112	1	< 0.1%
110	1	< 0.1%

total sulfur dioxide
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	276
Distinct (%)	5.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	114.1770578

Minimum	6
Maximum	440
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	41.6 KiB

Quantile statistics

Minimum	6
5-th percentile	19
Q1	75
median	116
Q3	154
95-th percentile	205.6
Maximum	440
Range	434
Interquartile range (IQR)	79

Descriptive statistics

Standard deviation	56.76962257
Coefficient of variation (CV)	0.497206914
Kurtosis	-0.299444838
Mean	114.1770578
Median Absolute Deviation (MAD)	39
Skewness	0.06199830104
Sum	606166
Variance	3222.790046
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
111	54	1.0%
113	50	0.9%
114	49	0.9%
122	48	0.9%
98	48	0.9%
128	46	0.9%
110	43	0.8%
101	43	0.8%
104	43	0.8%
117	43	0.8%
Other values (266)	4842	91.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
6	2	< 0.1%
7	4	0.1%
8	11	0.2%
9	14	0.3%
10	24	0.5%
11	22	0.4%
12	26	0.5%
13	25	0.5%
14	30	0.6%
15	28	0.5%

Value	Count	Frequency (%)
440	1	< 0.1%
366.5	1	< 0.1%
344	1	< 0.1%
313	1	< 0.1%
307.5	1	< 0.1%
303	1	< 0.1%
294	1	< 0.1%
289	1	< 0.1%
282	1	< 0.1%
278	1	< 0.1%

density
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	996
Distinct (%)	18.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.9945350235

Minimum	0.98711
Maximum	1.03898
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	41.6 KiB

Quantile statistics

Minimum	0.98711
5-th percentile	0.98984
Q1	0.9922
median	0.99466
Q3	0.99678
95-th percentile	0.999172
Maximum	1.03898
Range	0.05187
Interquartile range (IQR)	0.00458

Descriptive statistics

Standard deviation	0.002968020321
Coefficient of variation (CV)	0.002984329612
Kurtosis	8.697280558
Mean	0.9945350235
Median Absolute Deviation (MAD)	0.00226
Skewness	0.6652792038
Sum	5279.98644
Variance	8.809144625 × 10^-6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.992	59	1.1%
0.9972	59	1.1%
0.998	53	1.0%
0.9928	53	1.0%
0.9976	52	1.0%
0.9932	50	0.9%
0.9968	50	0.9%
0.9934	50	0.9%
0.9962	49	0.9%
0.9966	48	0.9%
Other values (986)	4786	90.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.98711	1	< 0.1%
0.98713	1	< 0.1%
0.98722	1	< 0.1%
0.9874	1	< 0.1%
0.98742	2	< 0.1%
0.98746	2	< 0.1%
0.98758	1	< 0.1%
0.98774	1	< 0.1%
0.98779	1	< 0.1%
0.98794	1	< 0.1%

Value	Count	Frequency (%)
1.03898	1	< 0.1%
1.0103	1	< 0.1%
1.00369	1	< 0.1%
1.0032	1	< 0.1%
1.00315	2	< 0.1%
1.00295	1	< 0.1%
1.00289	1	< 0.1%
1.0026	2	< 0.1%
1.00242	1	< 0.1%
1.00241	1	< 0.1%

pH
Real number (ℝ_≥0)

Distinct	108
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.224330382

Minimum	2.72
Maximum	4.01
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	41.6 KiB

Quantile statistics

Minimum	2.72
5-th percentile	2.98
Q1	3.11
median	3.21
Q3	3.33
95-th percentile	3.5
Maximum	4.01
Range	1.29
Interquartile range (IQR)	0.22

Descriptive statistics

Standard deviation	0.1601821357
Coefficient of variation (CV)	0.04967919435
Kurtosis	0.443686454
Mean	3.224330382
Median Absolute Deviation (MAD)	0.11
Skewness	0.3938210819
Sum	17117.97
Variance	0.0256583166
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.16	156	2.9%
3.22	154	2.9%
3.14	146	2.8%
3.15	144	2.7%
3.2	142	2.7%
3.24	141	2.7%
3.18	139	2.6%
3.19	136	2.6%
3.12	130	2.4%
3.17	128	2.4%
Other values (98)	3893	73.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2.72	1	< 0.1%
2.74	2	< 0.1%
2.77	1	< 0.1%
2.79	2	< 0.1%
2.8	3	0.1%
2.82	1	< 0.1%
2.83	3	0.1%
2.84	1	< 0.1%
2.85	6	0.1%
2.86	8	0.2%

Value	Count	Frequency (%)
4.01	2	< 0.1%
3.9	2	< 0.1%
3.85	1	< 0.1%
3.82	1	< 0.1%
3.81	1	< 0.1%
3.8	2	< 0.1%
3.79	1	< 0.1%
3.78	2	< 0.1%
3.77	2	< 0.1%
3.76	2	< 0.1%

sulphates
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	111
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.5332586174

Minimum	0.22
Maximum	2
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	41.6 KiB

Quantile statistics

Minimum	0.22
5-th percentile	0.35
Q1	0.43
median	0.51
Q3	0.6
95-th percentile	0.79
Maximum	2
Range	1.78
Interquartile range (IQR)	0.17

Descriptive statistics

Standard deviation	0.1497686145
Coefficient of variation (CV)	0.2808554979
Kurtosis	8.628636631
Mean	0.5332586174
Median Absolute Deviation (MAD)	0.08
Skewness	1.81276042
Sum	2831.07
Variance	0.02243063789
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.5	211	4.0%
0.46	196	3.7%
0.54	192	3.6%
0.44	184	3.5%
0.48	170	3.2%
0.38	164	3.1%
0.47	161	3.0%
0.52	161	3.0%
0.49	159	3.0%
0.45	157	3.0%
Other values (101)	3554	66.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.22	1	< 0.1%
0.23	1	< 0.1%
0.25	4	0.1%
0.26	3	0.1%
0.27	10	0.2%
0.28	12	0.2%
0.29	12	0.2%
0.3	23	0.4%
0.31	31	0.6%
0.32	44	0.8%

Value	Count	Frequency (%)
2	1	< 0.1%
1.98	1	< 0.1%
1.95	1	< 0.1%
1.62	1	< 0.1%
1.61	1	< 0.1%
1.59	1	< 0.1%
1.56	1	< 0.1%
1.36	3	0.1%
1.34	1	< 0.1%
1.33	1	< 0.1%

alcohol
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	111
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.54958812

Minimum	8
Maximum	14.9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	41.6 KiB

Quantile statistics

Minimum	8
5-th percentile	9
Q1	9.5
median	10.4
Q3	11.4
95-th percentile	12.7
Maximum	14.9
Range	6.9
Interquartile range (IQR)	1.9

Descriptive statistics

Standard deviation	1.186768661
Coefficient of variation (CV)	0.1124943123
Kurtosis	-0.539477493
Mean	10.54958812
Median Absolute Deviation (MAD)	0.9
Skewness	0.5463285558
Sum	56007.76333
Variance	1.408419855
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9.5	288	5.4%
9.4	260	4.9%
9.2	205	3.9%
10	204	3.8%
10.5	193	3.6%
11	175	3.3%
9.8	174	3.3%
9.3	169	3.2%
10.4	165	3.1%
10.2	157	3.0%
Other values (101)	3319	62.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
8	2	< 0.1%
8.4	4	0.1%
8.5	10	0.2%
8.6	16	0.3%
8.7	49	0.9%
8.8	66	1.2%
8.9	58	1.1%
9	136	2.6%
9.05	1	< 0.1%
9.1	126	2.4%

Value	Count	Frequency (%)
14.9	1	< 0.1%
14.2	1	< 0.1%
14.05	1	< 0.1%
14	11	0.2%
13.9	3	0.1%
13.8	2	< 0.1%
13.7	5	0.1%
13.6	11	0.2%
13.56666667	1	< 0.1%
13.55	1	< 0.1%

quality
Real number (ℝ_≥0)

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.7963835

Minimum	3
Maximum	9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	41.6 KiB

Quantile statistics

Minimum	3
5-th percentile	5
Q1	5
median	6
Q3	6
95-th percentile	7
Maximum	9
Range	6
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.8800401789
Coefficient of variation (CV)	0.1518257339
Kurtosis	0.2997344851
Mean	5.7963835
Median Absolute Deviation (MAD)	1
Skewness	0.1506900433
Sum	30773
Variance	0.7744707165
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
6	2317	43.6%
5	1750	33.0%
7	854	16.1%
4	204	3.8%
8	149	2.8%
3	30	0.6%
9	5	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3	30	0.6%
4	204	3.8%
5	1750	33.0%
6	2317	43.6%
7	854	16.1%
8	149	2.8%
9	5	0.1%

Value	Count	Frequency (%)
9	5	0.1%
8	149	2.8%
7	854	16.1%
6	2317	43.6%
5	1750	33.0%
4	204	3.8%
3	30	0.6%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	type	fixed acidity	volatile acidity	citric acid	residual sugar	chlorides	free sulfur dioxide	total sulfur dioxide	density	pH	sulphates	alcohol	quality
0	0	2	7.0	0.27	0.36	20.70	0.045	45.0	170.0	1.0010	3.00	0.45	8.8	6
1	1	2	6.3	0.30	0.34	1.60	0.049	14.0	132.0	0.9940	3.30	0.49	9.5	6
2	2	2	8.1	0.28	0.40	6.90	0.050	30.0	97.0	0.9951	3.26	0.44	10.1	6
3	3	2	7.2	0.23	0.32	8.50	0.058	47.0	186.0	0.9956	3.19	0.40	9.9	6
4	6	2	6.2	0.32	0.16	7.00	0.045	30.0	136.0	0.9949	3.18	0.47	9.6	6
5	9	2	8.1	0.22	0.43	1.50	0.044	28.0	129.0	0.9938	3.22	0.45	11.0	6
6	10	2	8.1	0.27	0.41	1.45	0.033	11.0	63.0	0.9908	2.99	0.56	12.0	5
7	11	2	8.6	0.23	0.40	4.20	0.035	17.0	109.0	0.9947	3.14	0.53	9.7	5
8	12	2	7.9	0.18	0.37	1.20	0.040	16.0	75.0	0.9920	3.18	0.63	10.8	5
9	13	2	6.6	0.16	0.40	1.50	0.044	48.0	143.0	0.9912	3.54	0.52	12.4	7

Last rows

	df_index	type	fixed acidity	volatile acidity	citric acid	residual sugar	chlorides	free sulfur dioxide	total sulfur dioxide	density	pH	sulphates	alcohol	quality
5299	6485	1	5.8	0.610	0.11	1.8	0.066	18.0	28.0	0.99483	3.55	0.66	10.9	6
5300	6486	1	7.2	0.000	0.33	2.5	0.068	34.0	102.0	0.99414	3.27	0.78	12.8	6
5301	6487	1	6.6	0.725	0.20	7.8	0.073	29.0	79.0	0.99770	3.29	0.54	9.2	5
5302	6488	1	6.3	0.550	0.15	1.8	0.077	26.0	35.0	0.99314	3.32	0.82	11.6	6
5303	6489	1	5.4	0.740	0.09	1.7	0.089	16.0	26.0	0.99402	3.67	0.56	11.6	6
5304	6490	1	6.3	0.510	0.13	2.3	0.076	29.0	40.0	0.99574	3.42	0.75	11.0	6
5305	6491	1	6.8	0.620	0.08	1.9	0.068	28.0	38.0	0.99651	3.42	0.82	9.5	6
5306	6492	1	6.2	0.600	0.08	2.0	0.090	32.0	44.0	0.99490	3.45	0.58	10.5	5
5307	6495	1	5.9	0.645	0.12	2.0	0.075	32.0	44.0	0.99547	3.57	0.71	10.2	5
5308	6496	1	6.0	0.310	0.47	3.6	0.067	18.0	42.0	0.99549	3.39	0.66	11.0	6

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows